EMT Practice Test

1. Question Content...

---

Question1: Why is generating statistics on a table important to query performance?

Question2: Data Restrict Optimization does NOT accomplish which of the following?

Question3: When working with sequences, which statement will always be TRUE?

Question4: Which of the following default Guaranteed Resource Allocation settings is correct?

Question5: Which of the following is TRUE regarding distribution keys?

Question6: The optimizer estimates cost in units of:

Question7: When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?

Question8: What does "Plan 4.457" signify in the attached snapshot of a plan file?

Question9: What columns contain row count information in the system tables? (Choose two.)

Question10: What information is the NZDUMPSCHEMA command capable of outputting?

Question11: When a temporary table is created, where will the data be stored?

Question12: What are the two primary components of an S-Blade?

Question13: What is the maximum number of columns you can choose as organizing keys for a clustered base table?

Question14: Which of the following are valid types of scheduler rules? (Choose two.)

Question15: Which nzload operation statement is TRUE?

Question16: The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?

Question17: Which option does NOT trigger a HardwareNeedsAttention event?

Question18: What should be considered when selecting distribution key columns?

Question19: In order for an ODBC application running on Microsoft Windows to connect to Pure Data System for Analytics, which two steps must be performed? (Choose two.)

Question20: Select the statement about the ENABLE_USER_SCHEMA variable that is TRUE in a system using Netezza Performance Server Release 7.0.3 or higher.

Question21: Which procedural logic is NOT supported by NZPLSQL?

Question22: In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items should be configured? (Choose two)

Question23: The Pure Data System for Analytics implements which level of transaction isolation?

Question24: What are two considerations for usage of materialized views? (Choose two.)

Question25: Which of the following statements is NOT true about Short Query Bias?

Question26: Which statement is TRUE regarding any database user?

Question27: Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?

Question28: When using a CREATE TABLE statement, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

Question29: Which statement is TRUE regarding the NPS compression engine?

Question30: Which of the following will NOT show the current sessions on the Netezza server?

Question31: What is a view?

Question32: Which statement is TRUE about a simple load using external tables?

Question33: Which of the following statements is TRUE?

Question34: Which of the following is FALSE?

Question35: Which additional feature in NPS would you need to configure to use an audit database?

Question36: Netezza database accounts are NOT created and/or managed using

Question37: Which of the following is TRUE regarding Multiple Schema Support?

Question38: Which of the following cannot be found with an EXPLAIN statement?

Question39: Which of the following statements about temporary tables is TRUE?

Question40: Dropping an external table does which of the following?

Question41: Which statement about external tables is TRUE?

Question42: Which of the following system views will NOT show information about active queries?

Question43: Which of the following is a valid data type definition?

Question44: Which statement or operation will cause IBM Netezza Replication Services to use the "By- VALUE" replication gmethod?

Question45: What must be properly defined for a table in order to avoid data skew:

Question46: Which groups are used by default by Guaranteed Resource Allocation?

Question47: All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?

Question48: Which statement is true about queries on the Pure Data System for Analytics appliance?

Question49: Which statement about the Netezza System Health Check tool is TRUE?

Question50: Which event type can be used to monitor queries that exceed configured query timeout limits?

Question51: Which of the following is NOT true about the createxid column?

Question52: Here's an excerpt from a successful query execution plan file:

What does "DownloadTableNode distribute" indicate?

Question53: Which statement about nzrestore is NOT true?

Question54: When setting up a crontab entry, what must be done on a Pure Data System for Analytics server?

Question55: A database administrator enters the following command: "nzhealthcheck." Select the statement that is FALSE.

Question56: Within a single Pure Data System for Analytics, what is the fastest way to copy a very large table from database PROD to database TEST?

Question57: Short Query Bias is enabled by default. Which of the following is NOT an advantage of using Short Query Bias?

Question58: Which statement about the GROOM feature is TRUE?

Question59: What mechanism does NPS use for LDAP authentication?

Question60: Which statement regarding temporary tables is TRUE?

Question61: NPS syncs up which two folder structures between the active and passive hosts? (Select two)

Question62: What is the maximum supported size of a BLOB in NPS?

Question63: The CUSTOMER table is distributed on "c_custkey".
The ORDERS table is distributed on "o_custkey".
Please refer to the SQL Query below:

Which of the following statements is TRUE?

Question64: Given the following query: SELECT * FROM customers;
How does data flow through the Pure Data System for Analytics components?

Question65: Which of the following statements about temporary tables is TRUE?

Question66: Where are the NPS log files located on the host?

Question67: Which of the following can the NZDUMPSCHEMA command be used for?

Question68: Which log file should be reviewed to troubleshoot an intermittent SPU failure?

Question69: Which of the following invisible columns exists on every table in the database?

Question70: A stored procedure returning one value is created. Which two methods can be used to execute the procedure? (Choose two.)

Question71: What command would you use to create a query history database?

Question72: In Release 7.1 what happened to Gatekeeper registry settings?

Question73: What can be backed up using the nzbackup utility?

Question74: What is nzconvert used for?

Question75: In a UNIX 64-bit environment, a 64-bit application requires which software to execute SQL statements via ODBC? (Choose two.)

Question76: What CANNOT be measured and managed by system views?

Question77: After a successful upgrade, what must be done to place new session limits into effect?

Question78: A user performs a full backup of a database on Monday and a differential backup on Tuesday. On Wednesday what is the fastest method to ensure a complete backup of user data?

Question79: Which statement is TRUE regarding the NPS compression engine?

Question80: In NZPLSQL which of the following statements is TRUE?

Question81: When doing a CREATE SEQUENCE, which is always true about INCREMENT BY?

Question82: When might a user receive an "unable to serialize" error?

Question83: Which command is used to abort a user's SQL transaction?

Question84: Which of the following statements is TRUE when a table is created?

Question85: Which will guarantee that a zonemap is generated for the NAME column?

Question86: Which statement will cause IBM Netezza Replication Services to use "By-Value" instead of the "By-SQL" replication method?

Question87: What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

Question88: Dirty reads occur when a transaction reads data that is written by concurrentuncommitted transactions.
Under what conditions are dirty reads allowed on the IBM PDA system?

Question89: Which log directories will record system state changes? (Choose two)

Question90: Here's an excerpt from a successful query execution plan:

Which of the following statements is TRUE?

Question91: What two conditions must be met to achieve a co-located join between two tables without a dynamic redistribution? (Choose two.)

Question92: Which command will backup users and groups on the system?

Question93: What will prevent a GROOM TABLE command from running on a table?

Question94: How are security labels represented?

Question95: What will occur when two large tables are joined together and the data is NOT co-located?

Question96: The CUSTOMER table has one column, customerid. Which statement can be used to determine the data skew of the table?

Question97: Columns in a table may be zone mapped. How are those columns chosen?

Question98: Which of the following statements will create a row secure table?

Question99: If nzload is being used to load data into the customer table, which of the following operations will be blocked until the load has completed?

Question100: What database object in the history database will you use to find the version number of the history database?

Question101: What is the host Linux file that must be modified to permanently adjust optimizer settings such as enabling schema support?

Question102: When reviewing the output of an EXPLAIN PLANGRAPH in IBM Netezza Performance Portal, how is the output read?

Question103: The DBA created and loaded the table CUSTOMER as follows:

Please refer to the excerpt (highlighted in bold) of a successful query execution plan which used the CUSTOMER table.

Which of the following statements is TRUE?

Question104: Which file format is NOT supported by the nzload utility?

Question105: Which of the following is FALSE about clustered base tables (CBT)?

Question106: What method will show only the deleted rows on the CUSTOMER table?

Question107: What two types of actions can be configured using the NZ Event Manager? (Choose two)

Question108: What is the function of the Distributed Replicated Block Device (DRBD)?

Question109: Which of the following criteria can be limited for active plans? (Choose two.)

Question110: Which two characteristics describe materialized views? (Choose two.)

Question111: Why should Boolean data types be avoided when selecting a distribution key for a table?

Question112: What is the maximum factor that page granular zone maps can improve performance over extent- based zone maps?

Question113: A thermal fault has occurred. Where would more information be found regarding the problem?

Question114: What statement about LDAP security is TRUE?

Question115: What new feature simplifies the gathering of information for a problem management record (PMR) with IBM Support?

Question116: With LDAP enabled, which of the following can be verified against an LDAP server?

Question117: What is the naming convention for system views?

Question118: A user is logged onto the PROD database. The user has access to other databases on the same appliance. Which types of objects from other databases can the user reference in queries?

Question119: Which attribute CANNOT be defined for both users and groups?

Question120: A user is running Netezza Performance Server Release 7.0.3 on an environment where cross- database access has been enabled. The user sees the following prompt:
DEV(ADMIN)=>
Which two sets of statements will execute successfully? (Choose two.)

Question121: Which of the following properties about the rowid column is FALSE?

Question122: Which of the following will NOT change the priority of all jobs in a session?

Question123: When creating a table with nullable columns, which statement is TRUE?

Question124: Why is it important to manage data skew?

Question125: nzload is invoked with the "allowReplay" option enabled- If the state changes from online to pausing then to online, which statement is TRUE?

Question126: Which of the following is NOT performed by the nzhw utility?

Question127: Which of the following statements about rowids is TRUE?

Question128: Which of the following statements is TRUE for an audit database in use?

Question129: What utility is used to find out which host is currently active?

Question130: Which of the following is NOT a Prioritized Query Execution priority level?

Question131: A user has access to two databases, DEV and PROD. Currently the user is connected to the DEV database.
Which operation is permitted?